﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create PROCEDURE [dbo].[proc_GetCompanyCountByBH]
	@bh varchar(20)
AS
BEGIN
	
	SELECT count(1) from Company where CompanyNumber=@bh group by CompanyNumber 
	
END